Domovská stránka Prehľadávať Pomoc
Prihlásiť sa
laisx
/
yilv_new
1
0
Fork 0
Súbory Issues 0 Pull requesty 0 Wiki
Branch: master
Branche Tagy
yilv_new
/
AA
/
Report
/
sql
/
[UFMeta]单据对照表.sql

[UFMeta]单据对照表.sql 19 KB
Permanentný odkaz História Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107 
  1. -- UAP报表脚本(数量:  1张 生成时间:2019年8月23日 16:31)
    2. 

  2. --  1.单据对照表( 1个视图,项目号U8CUSTDEF)
    3. 

  3. 

  4. -- "单据对照表"
    5. 

  5. -- 添加新的UAP报表
    6. 

  6. -- 插入项目信息
    7. 

  7. DELETE FROM uap_projects WHERE cProjectNum=N'U8CUSTDEF' 
    8. 

  8. INSERT INTO uap_projects(cProjectId,cProjectName,cProjectDescription,cCreater,cSub_Products,bOpened,dLastDate,bShared,iSharedType,dCreateDate,cProjectNum,iOrder)VALUES(N'65b883c7-3d78-4f16-ba03-326a852ac7c2',N'客户化',N'U8 UAP 客户化项目',N'demo',N'SA,',N'1',N'2019/8/21 18:57:15',N'0',N'0',N'2006/10/24 14:11:29',N'U8CUSTDEF',N'1')
    9. 

  9. GO
    10. 

  10. 

  11. -- UAP报表数据报表级基础信息
    12. 

  12. DELETE FROM UAP_Report WHERE ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' 
    13. 

  13. INSERT INTO UAP_Report(ID,FilterID,DataSourceID,FunctionName,Description,ProjectID,SubID,ClassName,FilterClass,bVB,bSystem,Creator,CreatedTime,bPublished,HelpFileName,HelpIndex,HelpKeyWord,bHadUpgradedFrom861,MappingMenuId,RootReportId,CanSaveAs,DataSourceIdExtended,bUsingReport4MenuId,IsNeedBak)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'b0465d91-8178-40df-812d-c3d79a66aa1e',N'Function1',N'',N'U8CUSTDEF',N'SA',N'',N'',N'1',N'0',N'demo',N'2019/8/23 16:19:55',N'0',NULL,NULL,NULL,N'1',N'SARPT232635',NULL,N'1',NULL,N'1',NULL)
    14. 

  14. GO
    15. 

  15. 

  16. DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' AND LocaleID=N'en-US' 
    17. 

  17. INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'en-US',N'单据对照表',NULL,N'0')
    18. 

  18. DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' AND LocaleID=N'zh-CN' 
    19. 

  19. INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'zh-CN',N'单据对照表',NULL,N'0')
    20. 

  20. DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' AND LocaleID=N'zh-TW' 
    21. 

  21. INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'zh-TW',N'单据对照表',NULL,N'0')
    22. 

  22. GO
    23. 

  23. 

  24. DELETE FROM UAP_ReportUserView WHERE ReportID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' 
    25. 

  25. INSERT INTO UAP_ReportUserView(UserID,ReportID,ViewID)VALUES(N'demo',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'f45802d3-ef66-42f6-965c-266d4756396e')
    26. 

  26. GO
    27. 

  27. 

  28. -- UAP报表数据源:可能包含进行扩展后的BO对象
    29. 

  29. DELETE FROM BD_BusinessObjects WHERE MetaID=N'b0465d91-8178-40df-812d-c3d79a66aa1e' 
    30. 

  30. INSERT INTO BD_BusinessObjects(MetaID,Name,ProjectNo,SubNo,MetaInfo,Description,Catagory,VoucherType,bCompoundBO)VALUES(N'b0465d91-8178-40df-812d-c3d79a66aa1e',N'vouchermaps(2019-08-23 下午 16:31:37)',N'U8CUSTDEF',N'SA',N'<BusinessObject name="vouchermaps" description="单据对照表" descriptionCN="单据对照表" descriptionTW="" descriptionUS="" entityID="">
    31. 

  31. <Function type="Query" name="Function1" description="" descriptionCN="" descriptionTW="" descriptionUS="">
    32. 

  32. <DataQueries><Query name="Query1" querist="SQLQuerist" description="" descriptionCN="" descriptionTW="" descriptionUS="">
    33. 

  33. <Distinct value="False"/><ResultTable name="ResultTable1" description="" descriptionCN="" descriptionTW="" descriptionUS="" >
    34. 

  34. <Column name="vouchertype" dataType="String" description="单据类型" descriptionCN="单据类型" descriptionTW="" descriptionUS=""/>
    35. 

  35. <Column name="ccode" dataType="String" description="原始单号" descriptionCN="原始单号" descriptionTW="" descriptionUS=""/>
    36. 

  36. <Column name="newcode" dataType="String" description="新单号" descriptionCN="新单号" descriptionTW="" descriptionUS=""/>
    37. 

  37. <Column name="ddate" dataType="DateTime" description="单据日期" descriptionCN="单据日期" descriptionTW="" descriptionUS=""/>
    38. 

  38. <Column name="importdate" dataType="DateTime" description="导入日期" descriptionCN="导入日期" descriptionTW="" descriptionUS=""/>
    39. 

  39. <Column name="processdate" dataType="DateTime" description="处理日期" descriptionCN="处理日期" descriptionTW="" descriptionUS=""/>
    40. 

  40. <Column name="transtype" dataType="String" description="处理方向" descriptionCN="处理方向" descriptionTW="" descriptionUS=""/>
    41. 

  41. </ResultTable><Content type="Script" ToolType="Manual"><Select>Select * from wtu..v_datamaps</Select>
    42. 

  42. <Where></Where>
    43. 

  43. <OrderBy></OrderBy>
    44. 

  44. <GroupBy></GroupBy>
    45. 

  45. <Having></Having>
    46. 

  46. <From></From>
    47. 

  47. </Content>
    48. 

  48. </Query></DataQueries></Function></BusinessObject>',N'单据对照表',N'ReportBO',N'',N'0')
    49. 

  49. GO
    50. 

  50. 

  51. -- UAP报表过滤条件
    52. 

  52. DELETE FROM flt_DefineMeta_Cust WHERE FilterId=N'3EA74B43-73FB-451D-8897-47EA00FC5977'
    53. 

  53. DELETE FROM flt_DefineMeta_Cache WHERE FilterId=N'3EA74B43-73FB-451D-8897-47EA00FC5977'
    54. 

  54. 

  55. DELETE FROM flt_DefineMeta_Base WHERE FilterID=N'3EA74B43-73FB-451D-8897-47EA00FC5977' 
    56. 

  56. INSERT INTO flt_DefineMeta_Base(FilterID,ProjectNO,XMLExpression,SubNO,FilterName,FilterDesc,IsUpgrade,bLocked,cLockedBy,PersonItems)VALUES(N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'U8CUSTDEF',N'<root canceladvanceitemlist="" title="" behaviorclass="" hasgroupby="0"><filter><items><item projectno="U8CUSTDEF" position="10" name="importdate" reftype="2" refid="" commonlogic="uq" pointbit="-1" fieldname="importdate" fieldclass="" iscommon="1" mustinput="1" rangeinput="1" multselect="0" allowupdatecomparelogic="1" orlogic="0" showstyle="0" ispara="0" displayinportalview="0" autodisplaytext="0" isfacilitycondition="0" isjoinfulltextquery="0" format=""/></items></filter></root>
    57. 

  57. ',N'SA',NULL,NULL,N'0',NULL,NULL,NULL)
    58. 

  58. GO
    59. 

  59. 

  60. DELETE FROM flt_DefineMeta_Lang WHERE FilterID=N'3EA74B43-73FB-451D-8897-47EA00FC5977' AND LocaleID=N'en-us' 
    61. 

  61. INSERT INTO flt_DefineMeta_Lang(FilterID,LocaleID,XMLExpression,SubNO,ProjectNO,Title)VALUES(N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'en-us',N'<root><items><item name="importdate"/></items></root>',N'SA',N'U8CUSTDEF',NULL)
    62. 

  62. DELETE FROM flt_DefineMeta_Lang WHERE FilterID=N'3EA74B43-73FB-451D-8897-47EA00FC5977' AND LocaleID=N'zh-cn' 
    63. 

  63. INSERT INTO flt_DefineMeta_Lang(FilterID,LocaleID,XMLExpression,SubNO,ProjectNO,Title)VALUES(N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'zh-cn',N'<root><items><item caption="导入日期" columncaption="" enum="" name="importdate"/></items></root>',N'SA',N'U8CUSTDEF',NULL)
    64. 

  64. DELETE FROM flt_DefineMeta_Lang WHERE FilterID=N'3EA74B43-73FB-451D-8897-47EA00FC5977' AND LocaleID=N'zh-tw' 
    65. 

  65. INSERT INTO flt_DefineMeta_Lang(FilterID,LocaleID,XMLExpression,SubNO,ProjectNO,Title)VALUES(N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'zh-tw',N'<root><items><item name="importdate"/></items></root>',N'SA',N'U8CUSTDEF',NULL)
    66. 

  66. GO
    67. 

  67. 

  68. 

  69. -- UAP报表添加新的视图
    70. 

  70. -- UAP报表视图级基础信息
    71. 

  71. DELETE FROM UAP_ReportView WHERE ID=N'f45802d3-ef66-42f6-965c-266d4756396e' 
    72. 

  72. INSERT INTO UAP_ReportView(ID,ReportID,ViewType,Columns,BlandScape,GroupSchemas,PageMargins,PaperType,bSystem,LevelExpend,ViewClass,RowsCount,bShowDetail,PageSetting,Selfaction,PreservedField,CanSaveDefaultFormat,FontColorStyleId,cvieworder,bclassicrptview,reportmergecell)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'1',NULL,N'0',NULL,N'20,20,20,20',N'6',N'0',NULL,NULL,N'40',N'0',NULL,NULL,NULL,N'0',NULL,N'0',N'0',N'0')
    73. 

  73. GO
    74. 

  74. 

  75. DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'en-US' 
    76. 

  76. INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'en-US',N'单据对照表',NULL)
    77. 

  77. DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'zh-CN' 
    78. 

  78. INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'zh-CN',N'单据对照表',NULL)
    79. 

  79. DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'zh-TW' 
    80. 

  80. INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'zh-TW',N'单据对照表',NULL)
    81. 

  81. GO
    82. 

  82. 

  83. 

  84. -- UAP报表视图的格式信息
    85. 

  85. UPDATE UAP_ReportView SET ID=N'f45802d3-ef66-42f6-965c-266d4756396e',Format=NULL,RuntimeFormat=N'<RuntimeFormat Id=""><RuntimeFormatGroupFormat Id="00000000-0000-0000-0000-000000000001"><RuntimeFormatGroupStyle IsFoldRow="False" Id="Plane.WithDetail"><RuntimeFormatGroupLevel Id="1"><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="0" IsMerge="False" Id="vouchertype" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="1" IsMerge="False" Id="ccode" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="2" IsMerge="False" Id="newcode" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="3" IsMerge="False" Id="ddate" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="4" IsMerge="False" Id="importdate" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="5" IsMerge="False" Id="processdate" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="6" IsMerge="False" Id="transtype" /></RuntimeFormatGroupLevel></RuntimeFormatGroupStyle></RuntimeFormatGroupFormat></RuntimeFormat>',Chartstring=NULL WHERE ID=N'f45802d3-ef66-42f6-965c-266d4756396e' 
    86. 

  86. GO
    87. 

  87. 

  88. UPDATE UAP_ReportView_Lang SET ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e',LocaleID=N'en-US',Format=NULL WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'en-US' 
    89. 

  89. UPDATE UAP_ReportView_Lang SET ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e',LocaleID=N'zh-CN',Format=NULL WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'zh-CN' 
    90. 

  90. UPDATE UAP_ReportView_Lang SET ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e',LocaleID=N'zh-TW',Format=NULL WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'zh-TW' 
    91. 

  91. GO
    92. 

  92. 

  93. -- 备份的原始视图格式
    94. 

  94. -- 颜色字体方案
    95. 

  95. -- 功能权限
    96. 

  96. DELETE FROM UAP_ReportView_AuthId WHERE ViewGuid=N'f45802d3-ef66-42f6-965c-266d4756396e' 
    97. 

  97. INSERT INTO UAP_ReportView_AuthId(ViewGuid,ReportGuid,ReportId,ViewIndex,IsReportApplyAuthControl)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'_f45802d3-ef66-42f6-965c-266d4756396e',N'1')
    98. 

  98. GO
    99. 

  99. 

  100. -- 视图的字段权限
    101. 

  101. 

  102. -- 门户菜单相关
    103. 

  103. -- 联查功能
    104. 

  104. 

  105. -- 报表自定义事件
    106. 

  106. 

  107.